Retail Agent Aged Accounts Receivable Report

The Retail Agent Aged Accounts Receivable report will show transactions that are unpaid or due from a Retail Agent displayed in aging categories, in detailed or summarized format.

To Generate an Aged Accounts Receivable Details Report 

1. On the Primary menu, click REPORTS.
2. On the REPORTS menu, click Reports. The Nexsure Reports dialog box is displayed.

3. In the Report Type list, select Accounting.
4. In the Report Category list, select Accounts Receivable. 
5. In the Available Reports list, select Retail Agent Aged Account Receivable. 
6. Click OK. The summary tab is displayed showing the report selected in the header area.

7. On the Navigation Toolbar, click New Report Criteria to go to the Nexsure Reports > Report Criteria dialog box.

8. Under Organization Information, click [Select]. The Nexsure Organization Criteria dialog box is displayed.

9. In the Nexsure Organization Criteria dialog box, select the desired organization information (in the Region, Territory, Branch, Department, and Unit lists) to query for the report and click Add.  

Note: If the report is being run for the entire organization it is not necessary to make a selection in the Nexsure Organization Criteria dialog box. Only one Region, Territory, or Branch may be selected for each report. When filtering by Department or Unit, add the Branch first then add the Department or Unit. 

Once information has been added to the Include list, it can be removed by selecting the item and clicking Del to remove individual items or Clear to remove all items.

10. If the organization information is correct, click OK. The organization information selected is added to the Nexsure Reports > Report Criteria screen.
11. In the Date Information area, select date filters. Date filters are used to set the beginning and ending date of the report. 

The available options are:

• Date Type: Select either As Of Date or Date Range.
• As Of: Set the end date of the report by using either the calendar dialog box or entering a date in the box.
• Period: Periods can be selected from the Period list, which are based on agency accounting periods or can be entered manually if the desired date range does not fall within the standard accounting periods. Period range filters will return all transactions with a balance due within the date range of the report at that time.
• Year: Fiscal years based on the general ledger periods and default to current year.
• Date From: Start date for a selected period.
• Date To: End date for the selected period.

12. In the Retail Agent Information area, click the Ellipsis button to open a list of retail agents to make a selection.

12. In the Client Information area, click the Ellipsis button to open the Client Name dialog box. Select the client or multiple clients and click the [Select] link to return to the Report Criteria dialog box.

12. In the Retail Agent Assignment Information area, use the Ellipsis button to open the Assignment Name dialog box. Select the appropriate name.

In the Responsibility list, select the responsibility for the selected assignment name.

14. In the Grouping / Sorting Options area, make selections to group and sort the report to change the report layout.

The available options are:

• Group Field [1]: Apply a primary grouping by RA Assignment Name (default), Territory, Region, Branch, Department, and Unit.
• Sort Field [1]: Sort transactions in ascending order within groups. Options include Client Name (default), Date Booked, Invoice Number, Line of Business, Policy Number, and Receivable Type.
• Sort Order: Sort Order: Select either Ascending or Descending to sort transactions within the group field selected. Ascending will set the order from A-Z. Descending will set the order from Z-A.

15. In the Aging Options area, select from the following options:

• Aged Number 1: Set the number of days to age open invoices. If left blank, will default to 30 days.
• Aged Number 2: Set the number of days to age open invoices. If left blank, will default to 60 days.
• Aged Number 3: Set the number of days to age open invoices. If left blank, will default to 90 days.

15. In the Page Break Options area, select whether or not a page break is desired between the Group By [1] headers by selecting Yes or No in the Page Break list..

16. In the Output Options area, make a selection in the following:

In the Summarize By list, the available options are:

• Client
• Invoice
• Retail Agent

4. In the Report Format Options area, select one of the options in the Format Type list.

The available formats are:

• PDF: This is the default setting that creates the report in a PDF format. The report data is static and cannot be manipulated.
• XLS: Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with the same formatting used in the PDF format so cells are merged and data may not be stored in individual cells.
• DOC: Microsoft® Word document that can be manipulated as a .doc file.
• XLS (unformatted): Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with no formatting so cells are not merged and data is stored in individual cells, however column headers do appear and page breaks are not inserted.

17. In the Nexsure Reports > Report Criteria dialog box, click OK. Retail Agent Aged Accounts Receivable report will start compiling. 

18. To update the compiling status, click Refresh on the navigation toolbar. 

19. Once the report Status is Complete, click the View icon to view the report.  

Related Topics

Working with Reports